home *** CD-ROM | disk | FTP | other *** search
- REM
- REM C714722.SQL 95/10/4 Copyright (c) 1995 Oracle Corporation
- REM
- REM This SQL script is used in migrating a Personal Oracle7
- REM for Windows 3.1 databse to Personal Oracle7 for Windows 95.
- REM
- REM It is a sample file which is editied to migrate the files
- REM for a specific database. The files listed are the default
- REM database files that are used by the starter database for
- REM Personal Oracle7 for Windows 3.1. C:\ORAWIN is assumed
- REM to be the Oracle_Home directory for Personal Oracle7 for
- REM Windows 3.1 and D:\ORAWIN95 is assumed to be the
- REM Oracle_Home directory for Personal Oracle7 for Windows 95.
- REM
- REM For each database file the full file pathanme must be
- REM provided for both the original file location and the
- REM location to which it being moved.
- REM
- alter database rename file
- 'C:\ORAWIN\DBS\WDBRBS.ORA',
- 'C:\ORAWIN\DBS\WDBSYS.ORA',
- 'C:\ORAWIN\DBS\WDBTEMP.ORA',
- 'C:\ORAWIN\DBS\WDBUSER.ORA',
- 'C:\ORAWIN\DBS\WDBLOG1.ORA',
- 'C:\ORAWIN\DBS\WDBLOG2.ORA'
- to
- 'D:\ORAWIN95\DATABASE\WDBRBS.ORA',
- 'D:\ORAWIN95\DATABASE\WDBSYS.ORA',
- 'D:\ORAWIN95\DATABASE\WDBTEMP.ORA',
- 'D:\ORAWIN95\DATABASE\WDBUSER.ORA',
- 'D:\ORAWIN95\DATABASE\WDBLOG1.ORA',
- 'D:\ORAWIN95\DATABASE\WDBLOG2.ORA'
- ;
-
-
-